<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateRoleTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('role', function (Blueprint $table) {
            $table->bigIncrements('id')->comment("角色ID主键");
            $table->integer('role_id',10)->comment('角色ID');
            $table->string('role_code',30)->comment('角色编码');
            $table->string('title',30)->comment("角色名称");
            $table->integer('psort')->comment("排序");
            $table->string('description',255)->comment("描述");
            $table->tinyInteger('status')->comment("状态0,不显示，1显示");
            $table->tinyInteger('is_delete',2)->default('1')->comment('是否删除，1正常2删除');
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('role');
    }
}
